|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Indigo Morchebe
BSC LEGION
Tactical Narcotics Team
0
   |
Posted - 2011.11.09 22:48:00 -
[1] - Quote
Total noob question...
I have done the following:
FTPed the files to the right folders
imported the sql files (x3) using myphpadmin
followed the instructions in the first two posts
checked cURL is enabled
cleared cache
phpbb version 3.0.9 clean install
turned off Spam counter measures in ACP
Edit:
I have set Enable API validation ON
I have set Enable Corporation management ON with correct details
tried registering a new user but the reg seems to be not passing to the mod...
In the phpbb ACP - User registration settings which Account activation type do I choose? |
Indigo Morchebe
BSC LEGION
Tactical Narcotics Team
0
|
Posted - 2011.11.10 01:37:00 -
[2] - Quote
Well... some success
I am not sure which change helped but...
I downloaded the latest 5.1 files and reloaded them but also cleared the styles cache as well...
I am now getting the additional two api fields - however i now get this error when registering...
General Error
SQL ERROR [ mysqli ]
Unknown column 'eveapi_keyId' in 'field list' [1054]
An SQL error occurred while fetching this page. |
Indigo Morchebe
BSC LEGION
Tactical Narcotics Team
0
|
Posted - 2011.11.10 21:08:00 -
[3] - Quote
PHPMYADMIN
I had to re-import a few times as there was errors but eventually all three were successful
it would not kill me to start a new db for that matter. |
Indigo Morchebe
BSC LEGION
Tactical Narcotics Team
0
|
Posted - 2011.11.10 21:31:00 -
[4] - Quote
I did a search for field list within the db and looked through 12 tables but I didnt find the 'eveapi_keyId' Unknown column
Not being a db techie I will start with a clean db and do the import with mysql tools |
Indigo Morchebe
BSC LEGION
Tactical Narcotics Team
0
|
Posted - 2011.11.10 23:11:00 -
[5] - Quote
Hmm...
Started from scratch and still get the same error. I have narrowed it down to the "default.sql" file import. I am getting an error on import
Error
SQL query:
ALTERTABLE phpbb_users ADDCOLUMN eveapi_keyId INTUNSIGNED NOTNULL DEFAULT0 AFTER user_reminded_time;
#1146 - Table 'mycorp_forum.phpbb_users' doesn't exist |
Indigo Morchebe
BSC LEGION
Tactical Narcotics Team
0
|
Posted - 2011.11.10 23:51:00 -
[6] - Quote
Firstly my apologies for the running commentary
I have found the fault.
Installing a non standard phpbb was the cause...
phpbb install - Database settings - prefix for tables in database - "phpbb_"
and I have always put the following "phpbb_forums" so the tables in default didnt match. Come to think of it this would explain some other strange mod outcomes as well.
So the table mycorp_forum.phpbb_users definately didnt exist as it was called mycorp_forum.phpbb_forumsusers' |
|
|
| |
|